CREATE TABLE [dbo].[SincronizacionOnline](
	[PK_IdSincronizacion] [int] IDENTITY(1,1) NOT NULL,
	[Fk_IdVenta] [int] NOT NULL,
	[Sincronizado] [bit] NOT NULL,
	[Reintentos] [int] NOT NULL,
	[Fk_IdTipoTransaccion] [int] NOT NULL,
	[FechaEnvio] [datetime] NULL,
 CONSTRAINT [PK_IdSincronizacion] PRIMARY KEY CLUSTERED 
(
	[PK_IdSincronizacion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]



--Trigger

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:	<Author,,Leonardo Hernandez>
-- Create date: <11/07/2017>
-- Description:	<Description,,>
-- =============================================
ALTER TRIGGER [dbo].[SincronizacionOnline]
   ON  [dbo].[Venta]
   AFTER Insert
AS 
BEGIN
	
	INSERT INTO [dbo].[SincronizacionOnline] ([Fk_IdVenta],[Sincronizado])
           Values((SELECT [Pk_IdVenta] FROM inserted),'false')


GO